Rollback
The RollbackRun can be executed, to revert the database changes that are partially applied for Initial / Subsequent / Alias Run. When Rollback Run is executed the changes that are applied partially in the Target database will be reverted back, based on the current state of the Target database with reference to the previous Run snapshot.
Steps to Execute Rollback Run
Step 1: When Initial / Subsequent / Alias Run is executed partially in the Target database, the Run status will be displayed as "ChangesPartiallyApplied" on the Run screen with a Rollback icon displayed in Action column of the Run record.
Step 2: Click Rollback icon. A Rollback run is created with Rollback Run GUID. The Run status will be displayed as ChangeLogStarted on the Run screen.
Step 3: Click Refresh. The Run status will be displayed as ChangeLogComplete on the Run screen.
Note: Keep clicking the Refreshto get the latest execution status displayed on the Run screen.
The Action Column of the table displays the below action icons. When the row expander button of the Subsequent Run record is clicked, the Subsequent Run details are displayed. The Action Column of the table displays the action icons.
Preview
When Preview is clicked, shows the Target DDL and Staging DDL scripts generated under its respective links.
Execute:
- Click Execute.
- Enter Target, Staging Database Username and Passworddetails and click Execute. The scripts that are generated to revert the applied changes will be executed on the Target and Staging databases. The Rollback Run status is updated as Complete in the Run Screen. The Run status for the Rolled back run (Initial / Subsequent / Alias ) will be updated as "Reverted".
Note: Keep clicking the Refreshto get the latest execution status displayed on the Run screen.
Download:
When Download is clicked, the Target & Staging DDLs will be downloaded in a (.zip) file, which the user can execute manually to apply the scripts to the Target and Staging databases.
Discard:
When Discard is clicked, the Rollback run execution changes are discarded and the Run status will be updated as Discarded.
In case Run execution fails, Run status will be updated as ExecutionFailed